Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- Query string

  Why (offset, limit) is slow in database select?

Starting from a problem Five years ago when I was working at Tencent, I found that MySQL request speed was very slow in the pagination scenario. With only 100,000 data, a select query on a single machine took about 2-3 seconds. I asked my mentor why, and he asked in return, "In an indexing scenario, what is the time complexity to get the nth largest number in MySQL?" The pursuit of the answer Confirming the scenario Assuming there is an index on the "status" column, a query like "select * from t...

   SLOW,LIMIT,OFFSET,MYSQL     2023-03-12 05:21:02

  Go是一门面向对象的编程语言吗

Golang已经开源了13年，在最近的TIOBE编程语言排名中，于2023年3月再次进入前十名，并比2022年底的排名上升了两个位置。 Go在2022年底提高了2个排名 许多第一次接触Go的开发者来自面向对象的编程语言，比如Java、Ruby等，他们在学习Go后第一个问题通常是：Go是一种面向对象的语言吗？在本文中，我们将探讨这个问题。 追溯 在广为人知的Go编程语言“圣经”《The Go Programming ...

   OOP,CHINESE,GOLANG,GO     2023-05-02 23:41:38

RECENT